SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038047 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038047 [ RunTime:0.002841s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (808687,236187,102012,122511,911829,935209,79451,48463,433972,421026,117590,44532,690165,238658,516996,732654,22158,150979,161205,372256,238442,680579,770683,639627,924709,805483,332186,500980,454962,628898,429092,297452,1030241,950679,35531,303132,240781,87459,659902,66101,378299,937766,706889,457917,929449,222495,143072,351840,657812,117479,97074,594124,289225,878068,374038,209095,91763,104291,880077,362290) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038047 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000515s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038047 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]