SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465758 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465758 [ RunTime:0.001830s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1016201,466371,460819,638759,592322,375342,871767,928534,383232,386011,684640,722442,944525,85198,234371,45782,439949,359521,201000,169518,383271,268636,317882,395483,6574,735957,211045,783439,855691,171051,174127,184708,426919,962475,11928,632193,475283,264116,604860,221328,799007,484883,668400,509544,358953,325305,556341,759592,123320,334070,156775,697204,139632,136827,382117,110749,999633,494804,417124,222984) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465758 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000807s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465758 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000691s ]