SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521310 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521310 [ RunTime:0.001558s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (541755,41023,988249,239487,71549,985365,216936,835012,725842,1027596,312624,670530,771539,818988,265421,783482,790925,365008,577840,1006751,50950,37617,449322,190107,48582,424621,672243,995522,306956,932037,392585,152262,782388,895878,979760,898956,345832,154781,303042,1038740,433937,983341,391722,414014,582611,338845,557626,497492,579152,148419,391093,138906,878386,623415,705342,413462,996227,566119,330575,562525) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000573s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000666s ]