SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 441975 LIMIT 1 [ RunTime:0.000461s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 441975 [ RunTime:0.002439s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (770243,996466,642149,837947,333991,494374,1005495,1041469,332209,605418,350425,1030267,627943,436539,705303,1016995,717918,1026534,289482,698932,340080,865647,798411,244799,108661,414768,202976,353443,890862,137482,474331,351809,769247,473688,846870,140490,308469,519629,151877,931184,407641,736911,526420,757968,32818,225072,353244,393749,910114,430188,267405,341688,415518,999223,484373,393014,330734,89417,1009758,699915) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 441975 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 441975 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]