SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413396 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413396 [ RunTime:0.001589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1030508,818556,270204,323126,959251,375951,754199,808548,155698,105339,192511,130772,115336,524362,1007139,1038263,881069,357793,109006,933185,943032,490274,451753,356498,196721,55701,480153,1010236,131125,706354,393703,977208,257613,35232,311874,162406,928994,1024199,165182,256508,299454,920350,511553,423086,227541,904825,707835,967736,234162,322178,807349,613238,316625,799031,912251,800846,841153,403794,971704,63035) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413396 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413396 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]