SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002760s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 524845 LIMIT 1 [ RunTime:0.000447s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 524845 [ RunTime:0.003721s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (108564,661745,729370,369396,794171,266607,837794,635352,424927,467427,1007897,120270,455771,91403,566904,110653,63768,752629,655077,326878,451826,533336,344714,32579,55784,873432,653821,95353,332576,728892,980895,454134,759006,1008853,588320,298415,322455,106548,481723,257514,112250,858799,528950,66436,162623,541263,530650,384570,114880,346675,745934,1014235,112243,3176,227353,185028,994621,438422,940941,700064) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001550s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 524845 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 524845 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]