SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503890 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503890 [ RunTime:0.001578s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (803293,464488,298966,693826,1002685,721347,100042,33186,906827,46751,507048,309575,318604,593128,338176,892181,750330,840790,228945,263402,709572,123367,3972,466964,235512,951489,740578,781859,403039,12413,892877,1021159,572478,106437,282061,801903,735540,346916,982234,994166,667755,540625,977922,107388,116137,167104,765719,677757,944216,831895,699607,671734,851912,901086,591183,17538,322606,247006,111816,469723) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503890 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503890 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]