SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536245 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536245 [ RunTime:0.001446s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1042793,616112,812380,63227,203973,280950,886216,332494,416360,126839,900420,439802,955836,751701,43450,129137,414557,978195,350913,803195,1024453,594688,159207,617638,561384,571760,548185,149735,551704,451824,376973,849189,610049,234873,612293,947745,71269,909024,1028594,294365,66616,328904,563636,136722,1010681,355612,1045204,559314,234711,10760,146901,146152,758488,570777,299345,95621,474904,595365,1042223,180221) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536245 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536245 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]