SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 312076 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 312076 [ RunTime:0.001732s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (320816,1039014,169782,108841,379246,799686,439111,140107,969520,331565,202232,729354,851231,612678,184460,737090,169292,9116,907957,833219,933664,1035325,991704,483779,306266,229479,564829,1011286,656582,678202,903349,739507,216490,887484,124537,1012277,889408,267328,577120,61578,597721,174181,316920,439128,665526,175775,719958,820496,14332,145611,39928,262819,214188,812150,858619,701000,855790,360335,310623,158970) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 312076 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 312076 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000651s ]