SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004754s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031179 LIMIT 1 [ RunTime:0.003808s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031179 [ RunTime:0.004485s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (409985,498112,783604,393180,303268,806359,198009,440218,999584,94365,969459,640063,520119,376884,453984,651353,80828,151318,1041060,167815,941868,260674,227599,196721,1035459,142588,514632,149882,491648,656660,303218,132092,992479,62238,446189,354414,132591,572398,983699,502472,947870,712438,495752,312111,390425,383006,19069,400038,464638,73153,746705,1025010,532240,183051,728431,499830,224093,501492,193842,560353) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002720s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031179 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031179 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000945s ]