SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010194 LIMIT 1 [ RunTime:0.000285s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010194 [ RunTime:0.001846s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (52690,527953,330502,895236,678797,582885,408881,866629,563988,464783,916662,1015306,1042659,951898,754105,758037,675212,417483,692487,98996,611493,849836,561166,1030335,260226,586962,412877,254713,1025957,942156,221744,384909,487160,528405,868575,224055,170016,220116,195568,789074,118164,445757,407689,570746,425960,540666,524063,686017,904953,550637,323616,125603,311706,207132,103000,305295,260708,523966,261094,812469) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010194 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010194 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]