SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402071 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402071 [ RunTime:0.002035s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (306798,1039868,326783,823749,439323,881076,605667,113892,209687,645646,75268,488173,423007,981920,679409,285334,305681,274234,410015,791163,789112,629107,610302,647708,520537,71772,298043,238767,822640,695227,563974,829883,464315,976817,961840,638981,442222,205187,219247,633247,898064,56154,970691,8116,501602,999717,416505,1005555,775961,569705,278536,242309,565154,136051,316314,515365,813639,636028,984092,63259) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]