SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002428s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040648 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040648 [ RunTime:0.002641s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (841823,418528,356508,240731,228441,302232,14635,738835,878462,515958,33325,292636,951459,634614,936861,1014429,580247,219776,186535,162632,465794,990067,1027238,724032,1036258,793117,828841,196713,924896,692752,589659,389484,698721,860623,1042569,785437,547560,131376,192333,461353,965589,452414,36163,809799,133498,364080,88045,986624,227111,359308,405893,761502,60934,105812,677774,981200,297619,703041,332287,641605) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040648 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040648 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]