SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 530908 LIMIT 1 [ RunTime:0.000849s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530908 [ RunTime:0.001733s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (602460,861895,432469,970901,337542,798238,448683,850599,273834,108161,802987,992394,809154,726868,853290,907192,318024,68959,741246,206845,103479,387808,372557,69662,911660,347797,63361,591622,278043,58647,757393,910409,675996,625829,218014,980324,111710,325570,1008662,102924,295807,984678,612671,926872,411455,14928,938151,269209,71652,27149,614982,593888,922854,564329,196506,875901,725069,116791,310878,610757) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002562s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]