SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 269046 LIMIT 1 [ RunTime:0.000283s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 269046 [ RunTime:0.001582s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (292638,698105,866051,617055,79774,75940,40730,962963,200993,17591,286639,633679,802861,175306,72227,640767,390633,369709,506415,811292,600174,369259,125945,741920,839460,151532,627927,401329,846837,799711,946123,286017,983814,379628,55061,856529,800069,475566,238637,372107,557123,589685,996259,723233,819423,338689,288521,515174,704474,821256,43592,852687,741931,757831,870677,621413,700219,625529,983801,61118) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 269046 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 269046 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]