SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012806 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012806 [ RunTime:0.003480s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (222823,261935,440542,386035,379004,772212,598153,819546,213155,214580,75676,808503,23066,119942,654086,973195,276114,345775,291635,914767,1022642,1026555,615046,648994,365198,239001,1025610,830809,978864,882815,813231,559585,53746,912990,524938,921797,107729,626544,913851,701127,288935,753077,402592,670761,328263,535678,616951,69047,302137,101713,346134,432168,424867,622866,785991,780343,289524,529955,940761,683179) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012806 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012806 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]