SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 254001 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 254001 [ RunTime:0.002784s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (285380,749641,363417,597091,610653,173061,105274,496829,675534,1041034,1032876,203680,65139,159049,241775,742033,552453,931917,139601,536840,588872,99401,619034,718634,797264,192230,961351,901447,728084,560162,629241,1030179,490249,259398,774788,729380,759777,414683,281677,17794,920758,475728,399129,89424,690244,623065,471540,37722,19217,205511,105938,188302,249347,50386,404548,818226,530831,819853,655110,64636) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 254001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 254001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]