SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 800081 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 800081 [ RunTime:0.001850s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (3225,265080,337368,440236,455778,979827,55603,115989,276584,662092,337604,863304,515791,355640,1020100,78358,849493,475115,1033772,680774,29042,996759,986979,193099,886873,502096,231590,695825,817898,932788,701746,62203,749836,413432,851062,675780,764435,418451,77852,76000,1008652,89567,768131,500616,115426,981971,375840,604411,587799,1388,546947,568565,642480,698162,316158,493345,224795,740240,24794,56838) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000959s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 800081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 800081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]