SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001358s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 114608 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 114608 [ RunTime:0.002301s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (518478,662112,500144,181346,192929,282212,319277,142767,271528,754338,926729,541219,609908,965252,759854,570302,384803,609982,496740,875534,26688,507288,824187,104769,941951,541316,119018,277959,621422,409896,871441,864770,590974,833113,185166,260799,714931,611984,461078,285323,770776,705535,487127,189502,233407,377271,539142,598810,763931,145838,686585,723193,188435,91009,864656,573472,436365,941100,492077,904663) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 114608 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 114608 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]