SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501925 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501925 [ RunTime:0.001854s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (652048,749587,1030327,164708,584611,979295,1042868,290794,131062,14396,112047,443741,31449,371227,747794,701476,46287,505984,119131,224876,811372,336413,680784,910069,314382,726541,174999,1024971,845148,823098,523883,718046,1048181,951229,599735,347544,198683,564162,905840,14332,998658,427363,20095,75597,597974,531486,825461,445749,105770,290444,580297,51679,638560,132599,832293,467692,799158,897787,577768,534639) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501925 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501925 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]