SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515223 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515223 [ RunTime:0.001804s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (261219,598248,138173,117291,629531,767008,256318,907390,216731,904136,159232,788832,49750,880066,397307,341734,718811,913335,761327,238694,691020,362575,492022,552906,292149,1017509,712806,410603,112517,467595,127453,232401,231500,68799,469454,203494,245506,989768,330733,685779,932170,822037,166059,201703,349045,52686,582720,70430,637161,398590,1040453,517002,552387,492378,873154,80200,852669,395034,38650,434545) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515223 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515223 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]