SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001488s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 593854 LIMIT 1 [ RunTime:0.000478s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 593854 [ RunTime:0.003313s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1035466,351400,543038,445707,148445,755050,356346,419795,144641,170153,352058,23553,1042156,451548,279240,894890,42149,145652,899217,659079,429572,448745,943494,477705,217233,823426,155685,115832,826834,579403,139759,17431,1045566,1033864,740576,864177,707476,282372,1020246,20180,325674,906102,706839,87070,100578,93364,877926,596606,409061,230881,372098,37730,550488,448493,622666,441014,293738,986058,80878,991274) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 593854 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 593854 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000847s ]