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` = 1038564 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038564 [ RunTime:0.002778s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (85926,575194,617682,464676,911232,370183,900927,407807,791512,622268,945710,933525,1039390,294654,539913,369849,311207,502091,840533,1006830,871419,848079,206251,894466,238068,270510,665202,339298,673338,583574,746532,930336,4170,409771,7259,528410,59711,154562,834750,149027,609603,656601,488283,575798,985862,674906,156029,814004,118476,968504,926049,426830,922680,521368,898190,162753,774585,29430,304374,691887) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038564 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000612s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038564 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]