SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001886s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511697 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511697 [ RunTime:0.001585s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (589399,557227,37383,151735,1042170,1012287,375418,795325,925171,881692,720180,887160,297351,398634,597805,38005,610973,411521,343743,196832,984846,803395,1040067,316112,269549,166769,895484,183119,281064,600096,123498,930208,179155,160810,986895,900020,656344,587757,16550,1009663,133120,272841,639139,243964,96760,977980,8981,600907,628776,486794,574098,1044363,5014,955506,188173,323902,745160,590585,98395,961736) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511697 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511697 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]