SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003830s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 479613 LIMIT 1 [ RunTime:0.002238s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 479613 [ RunTime:0.003256s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (864929,747744,552361,841969,153924,575407,623983,735404,674701,365102,439529,503727,543024,94222,177121,992026,1037939,138398,692450,242069,78451,400107,340827,601414,444158,232566,780957,164199,95905,668442,606489,247329,311958,257271,334035,224279,198735,486812,278841,940895,1047939,906039,641766,323783,166168,535251,252076,255755,220506,243673,988909,860668,385081,947722,158562,824860,925706,304811,699612,160193) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 479613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 479613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000920s ]