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` = 429630 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429630 [ RunTime:0.001619s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (833043,638002,250842,566168,395137,300781,332899,897507,771567,527276,351865,318949,961128,151050,1041423,730479,827790,680982,422310,642899,885027,508180,703732,750051,209132,208394,805733,244892,13462,208398,884204,475686,921612,906181,915345,351593,546671,398927,495105,252443,950777,899598,176027,857534,508145,816559,993433,855412,345940,754687,900220,86026,224458,908756,242820,152670,651813,186681,1039411,124614) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429630 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429630 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000780s ]