SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106743 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106743 [ RunTime:0.001735s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (63275,129658,729923,626487,236708,99628,1032811,433380,892454,279316,562268,1048185,940189,185292,448694,874021,754548,773612,235440,799649,50671,353956,273449,1013845,969370,351396,229012,9748,346368,739712,902939,898680,199548,484118,624424,714214,858045,34334,292652,466795,630171,448354,1032945,528484,964886,165516,130741,973405,875577,893857,601034,993848,1025671,477482,191101,839479,884472,257363,326083,902883) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]