SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502986 LIMIT 1 [ RunTime:0.005216s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502986 [ RunTime:0.002983s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (427439,674317,156028,16913,453548,885021,568606,929850,692796,28881,957759,518623,936464,552700,279795,249798,820429,272700,397104,649637,446741,827376,522642,34637,865222,1038164,166044,687486,191935,609734,924823,641870,337549,1007636,909172,648784,854263,299198,549803,278339,548405,320214,906927,255498,4407,914111,549415,414797,586563,750333,628389,484494,170401,808888,542393,138833,566368,831786,481857,353373) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502986 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502986 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]