SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 494413 LIMIT 1 [ RunTime:0.000453s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 494413 [ RunTime:0.003795s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (107210,854578,32067,107759,1001118,483810,959691,110948,705142,446585,679452,228353,121348,564246,1013941,501682,929285,686775,265584,3032,748268,16372,117357,353855,202381,725484,815800,198093,709977,989185,102877,70564,778742,704529,225748,861370,906827,809215,429671,388799,379039,182241,770404,1009378,13974,719260,407643,394023,533003,874465,718006,947020,221437,864591,88898,965788,668631,936168,1034209,405132) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 494413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 494413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]