SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108368 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108368 [ RunTime:0.001883s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (544494,479001,989063,781714,103015,408650,922467,492678,389136,705205,759870,374225,459881,462122,414801,165365,144153,308939,792661,119461,86392,111238,935502,527539,861216,158406,1044511,427612,235035,896738,305946,700202,266826,887559,94301,516512,778387,850034,735636,387741,619924,246467,561115,33838,67928,220454,171425,161650,1017459,354020,970449,536114,798686,159438,563913,372474,636457,349105,839109,396087) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108368 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108368 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000416s ]