SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465283 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465283 [ RunTime:0.001932s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (96404,933945,287520,248525,853966,146959,185010,798443,1039475,464256,781364,1023888,625201,377153,563081,804683,480849,462976,502433,413816,740251,376508,55527,881835,113539,625562,306254,287,352517,325170,494580,85318,393569,819692,162130,725086,287076,582026,556406,182318,571619,669839,578286,97384,513594,800154,481605,586964,991056,360239,800729,237038,898680,884014,494300,480077,779991,245573,595691,89596) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465283 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465283 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]