SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002434s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103075 LIMIT 1 [ RunTime:0.002631s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103075 [ RunTime:0.002211s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (593081,619894,267489,202536,657150,290600,972238,183657,780901,505967,685723,965123,881019,928666,780198,894119,297243,460564,941370,278948,295330,88449,299640,258156,9232,387115,486242,997739,933235,40029,926041,359352,358587,395138,803812,618534,133400,696039,335583,226680,900411,318563,72102,641901,393287,159509,906651,191329,259506,416134,514009,489913,932424,314039,24693,487801,680684,68929,422402,797221) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003198s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103075 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103075 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001885s ]