SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030716 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030716 [ RunTime:0.001543s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (459283,124784,508153,124585,567915,239897,433385,821499,319268,256823,719814,834959,202243,507021,479523,47147,1016233,135490,606809,459202,127283,93475,985636,427603,540789,364821,678934,13404,369269,213436,689299,545279,586382,163927,959091,384123,520794,29299,259644,631587,951395,602068,938824,1040500,796740,872395,488445,1045835,772582,173538,974811,604784,132475,277631,447636,773880,247601,811739,120915,113143) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030716 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030716 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]