SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 566528 LIMIT 1 [ RunTime:0.000458s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 566528 [ RunTime:0.003485s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (56127,297640,189310,221091,998106,774583,425475,1042466,967367,774478,635220,20332,565944,245519,961352,312549,622018,589036,70768,212432,937797,94995,210197,370980,495030,971818,594520,134612,212679,933847,297103,633241,232867,57187,171965,164115,949913,302487,686610,387503,354720,126798,19471,861769,213071,459366,774879,804797,73197,950126,78381,517730,374702,695781,955504,428160,278232,602375,392209,272202) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003634s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 566528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 566528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001279s ]