SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318099 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318099 [ RunTime:0.002693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (813022,1046931,184230,107291,589659,1042788,182069,69732,374288,2250,107828,105177,781200,1032475,142507,115277,59680,33180,187248,242916,702760,921108,922748,555392,602325,975302,795416,589263,371169,455581,877369,639413,733133,42559,132254,423487,779323,51402,100797,836249,26332,238849,574488,767449,421636,443236,880513,552727,991765,557940,489581,382633,869685,827361,345838,893873,344207,243733,65158,869866) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000744s ]