SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 449951 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 449951 [ RunTime:0.001628s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (667124,619828,241246,1040450,1037885,5092,916741,49379,115559,462492,259815,67684,813381,322064,367214,328211,324487,880486,496331,1015124,848926,19620,352615,847892,683221,741017,936808,798768,689174,1021396,129734,718340,784576,316427,202574,45884,303303,65470,626196,11477,764447,304937,404219,482715,579763,715620,497172,673232,547546,336165,926611,670660,88475,376140,539650,713680,402344,252144,13893,37627) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 449951 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 449951 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000828s ]