SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521106 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521106 [ RunTime:0.001643s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (267346,53179,645349,294800,673067,962329,308487,265567,822446,274074,606751,541900,561964,273318,113518,153651,435845,888579,655006,774161,631379,275578,398600,978226,557889,109790,349298,485890,699173,117125,235533,484299,254261,25139,175644,549346,76493,958553,5508,563952,802007,628078,110914,1031518,591110,1019825,459081,186873,755398,547058,690595,128863,424567,406052,779633,452455,808691,361588,694869,597503) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000962s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]