SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 524518 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 524518 [ RunTime:0.001669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (409543,449998,833295,638043,438638,751874,400610,4471,604339,938713,145376,350363,907935,384426,755984,306162,447557,89718,471735,377134,773534,108134,293098,376219,444768,576718,81751,531484,659155,121925,872034,855010,913305,879365,471819,1033177,833527,878462,539124,45371,160418,24778,891010,638909,953636,1017875,724149,763608,155159,199634,303291,505976,167555,512276,484397,334357,407195,498358,400686,957836) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 524518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 524518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000819s ]