SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429670 LIMIT 1 [ RunTime:0.000280s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429670 [ RunTime:0.002169s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (374790,854849,981712,552115,1037655,487551,350996,908980,123987,49235,283075,261778,915871,395521,1014518,91301,982100,869563,48287,726837,551124,537566,588224,1029125,262082,523565,358679,550595,691577,240767,333020,839804,965518,349306,689755,714897,849716,639720,142484,926858,535923,598550,445167,486491,596654,871180,195836,756714,499645,822674,664458,1022447,801684,988240,494404,737609,757658,412109,602408,18469) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429670 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429670 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]