SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 399151 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 399151 [ RunTime:0.001611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (763673,338840,186585,941648,658800,761051,158799,529995,412629,18875,961628,634861,458869,418597,104014,371472,381459,3734,775548,801330,955045,74357,220679,781995,292387,78210,821654,460803,320917,614707,300278,256482,339127,1040426,303621,64369,853828,18652,964970,854160,797776,115207,719829,715313,897161,524999,312033,1035480,268436,618354,967205,146196,295842,479449,253148,1026514,252647,310136,37065,675915) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 399151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 399151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000789s ]