SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002752s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 596541 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596541 [ RunTime:0.001730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (164980,115552,904843,134585,758154,551677,990274,411215,802701,482238,123221,588024,223961,251163,1040333,359652,237250,300478,314468,302882,341559,391172,102361,44192,155157,636025,161104,965923,505655,58204,78590,279810,442979,93636,1005399,993008,79146,1021203,497878,445435,201547,698226,468198,458122,968356,287702,323831,987771,744079,462075,415445,178117,903423,647299,191530,823132,718472,187997,64556,531100) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000966s ]