SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504928 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504928 [ RunTime:0.001557s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (305042,913217,711472,945851,233576,212834,88932,988300,11208,906638,894389,284557,755062,741244,30972,180405,55735,273363,908563,524030,113030,1031604,990204,145764,283698,43347,563697,147526,316845,461731,587188,18930,471983,542267,953154,721517,811569,674079,774376,241652,901865,942667,978996,776174,435355,964788,805387,841238,83939,256217,640495,926592,977469,283004,857300,654592,575045,188389,89474,555060) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000956s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003554s ]