SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517144 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517144 [ RunTime:0.001456s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (647629,867324,93678,161418,120436,429808,790609,951021,17996,790581,532496,809325,441055,537147,1042292,620991,184573,636561,670670,39115,63949,564472,335546,715997,30955,101238,390673,313506,352846,1022396,327550,592608,169015,466472,548471,815098,553016,986853,559941,669786,30838,632347,369472,984142,1023364,612403,963556,642367,959615,471097,615700,842005,174108,866162,981849,545218,318451,587338,609410,761272) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517144 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517144 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]